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