UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vWLCgqeuUYuSbE28PbsBlCvceQgSOtGbnbyVA+g20nE='
WHERE
key_id = '40012bd5eeb43eefb23424c9b969bf8596a848d0caabd31e231fcc9042a39752'
AND (
token = 'vWLCgqeuUYuSbE28PbsBlCvceQgSOtGbnbyVA+g20nE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)