UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xXgdAvtRZVq6bIwR+KsbevPe44Mp/+YSb55UCdnZuF0='
WHERE
key_id = '3cc95f5bab9cdd9f1d07704c9d506ed470c1b6725bda1f0e5498a96b2d8f0227'
AND (
token = 'xXgdAvtRZVq6bIwR+KsbevPe44Mp/+YSb55UCdnZuF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)