UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgtzZC6Ta44u9nwOElchUfN8FCtMP1qRRJbYL0PJZZ8='
WHERE
key_id = 'b7d7c27e2dbcd29ef72c9cc2e1b8de7b3ab09d81bdb942ab0e4cdc5bf2203b03'
AND (
token = 'sgtzZC6Ta44u9nwOElchUfN8FCtMP1qRRJbYL0PJZZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)