UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1m2eVU5gD020W0077kMSNv/WwWfQDCRHCECM3i+ZubI='
WHERE
key_id = 'ec986484f152b5606fb547b78342a079571e5085813698dc96ad97bf2aa9e9ee'
AND (
token = '1m2eVU5gD020W0077kMSNv/WwWfQDCRHCECM3i+ZubI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)