UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kSCqYQP00c/KPyd+RsI47zqmUbG1pZyUeopBPR+BHCA='
WHERE
key_id = '4e0fea5453104ccf413c18a3c7e1a7f29abb8f07a86b7d6e671e11b7f190c0ae'
AND (
token = 'kSCqYQP00c/KPyd+RsI47zqmUbG1pZyUeopBPR+BHCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)