UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gybvw9pA2H5P9jE8/7vDlUiJFtE/GhEZFFsZ1bMcR7w='
WHERE
key_id = '5dec0c96e9865d04b00a46fd94e05ca650d61f150d81e6cd8e8504cba43a6063'
AND (
token = 'gybvw9pA2H5P9jE8/7vDlUiJFtE/GhEZFFsZ1bMcR7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)