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