UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+XnclIxzw6/pI6Izd3SZhs3qHyzQXuUkyE9fweP34CY='
WHERE
key_id = '27917f0b30344284d951ad33f3819f61b64a66b668b4d6457087e6266b5310e8'
AND (
token = '+XnclIxzw6/pI6Izd3SZhs3qHyzQXuUkyE9fweP34CY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)