UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JX5z2YJfI4FOK2LyQR5W21fdEWTjYzuzgd+aR+/7iyc='
WHERE
key_id = '477d871832a1215a84bcf5b1c048f186d355e02f5a5f54d62021c9bf9426c370'
AND (
token = 'JX5z2YJfI4FOK2LyQR5W21fdEWTjYzuzgd+aR+/7iyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)