UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H1T76h6nVDbqvI9FbzQOAAebW+SwohwIHlP7Sy+GkQc='
WHERE
key_id = '78fdf6a803b4cc1b3cbac6fa5edcb75189d67f119171f74bbfcb2259300eff8a'
AND (
token = 'H1T76h6nVDbqvI9FbzQOAAebW+SwohwIHlP7Sy+GkQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)