UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TXA5unoicT3pDPuR5a5QFuogMz6eqUagsCQrNidOsY8='
WHERE
key_id = 'eba4f3c31228d48819990d94694a5ac243341e370471e40116963a03cb39b324'
AND (
token = 'TXA5unoicT3pDPuR5a5QFuogMz6eqUagsCQrNidOsY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)