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