UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+9djSJwvbmUcloq1hsl9GUiTsC6scyw/c5zXVfDpGHc='
WHERE
key_id = 'ddbbab7704e32fc917bbf54978677f63e4ecd967ad7557679caf783b6c28b7dd'
AND (
token = '+9djSJwvbmUcloq1hsl9GUiTsC6scyw/c5zXVfDpGHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)