UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uZ/o5ZMFpOQIKWVnsjG9Oa41yEsCasBcax8S5Aptvx4='
WHERE
key_id = 'db7691e015cc6b7a23a44a716503449f1602f151e11d6502fda293f1ce037683'
AND (
token = 'uZ/o5ZMFpOQIKWVnsjG9Oa41yEsCasBcax8S5Aptvx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)