UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1/3ldQl7Sg4+SokMmSGYByS9wbNtK2L+iIiWveppVQ4='
WHERE
key_id = 'a8a1229b53f8a5d2d9cbccfadc79b3cff3fb8f9e5cf824dfabb04b46d1cc5a30'
AND (
token = '1/3ldQl7Sg4+SokMmSGYByS9wbNtK2L+iIiWveppVQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)