UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vDpnLD71ft4amhhhXHaz4XKxp488hINperJyBeTcd14='
WHERE
key_id = '520589c63552390866a676ae97417a7ca97ac158b2cc6f7678d756d580071ba0'
AND (
token = 'vDpnLD71ft4amhhhXHaz4XKxp488hINperJyBeTcd14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)