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