UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E+P8iCsOEYuys0vxf+ENS4kha03hmcXQ9JOoL/rtlcE='
WHERE
key_id = '4bff18fc8b201149c15f514cf272411876769a4af6d11a266598908ec4c829fd'
AND (
token = 'E+P8iCsOEYuys0vxf+ENS4kha03hmcXQ9JOoL/rtlcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)