UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7eWONbzQcryo7YO5EXqXlm+nfRCqYeuStz8nd38Aiwc='
WHERE
key_id = 'fe47040ea12dc7aa7fe2d2ba39989b30f8150197bbc33e630079310ece19d194'
AND (
token = '7eWONbzQcryo7YO5EXqXlm+nfRCqYeuStz8nd38Aiwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)