UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y+fExPYmiEr3OQbagEvCe94bI3BsSvf+hS4DrRiZ14U='
WHERE
key_id = 'f0decb6d15da85f977364898e37be89d45cc2326175dadaed570c03ab2324bd9'
AND (
token = 'y+fExPYmiEr3OQbagEvCe94bI3BsSvf+hS4DrRiZ14U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)