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