UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8oWP2xhQ59jKyA86rkbI38HRtZh3paZtiMVonAGnpOM='
WHERE
key_id = 'bcff9e560613e097058fd3cb9577805eaa3ff7451ae7451e064b5dad6a45cab4'
AND (
token = '8oWP2xhQ59jKyA86rkbI38HRtZh3paZtiMVonAGnpOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)