UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '14rSP58QC9WnAGGwPqqm1f1p4EBidfeqhUAUPAqGSPU='
WHERE
key_id = 'a9942f59ed2d6a2b096b99ba7add61d775cd0b984389760c5546a5fd8de6d851'
AND (
token = '14rSP58QC9WnAGGwPqqm1f1p4EBidfeqhUAUPAqGSPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)