UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7tlBkoyPiirgIzb1k+EYrWt43I1Z3t6EuyLBhQ9pbOo='
WHERE
key_id = '48413a06fef2d3491590ab4d184990d8cef4b1dad1b7896bdfaba303abde4372'
AND (
token = '7tlBkoyPiirgIzb1k+EYrWt43I1Z3t6EuyLBhQ9pbOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)