UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ka7X7+CGCPmlt7cdfSA7HzkbUP58IVSBSBIJ/81VM0Q='
WHERE
key_id = 'a055c56bc5d36f7826ba4f03b54035d03257637787cc0b329ffa0a8b61138a3c'
AND (
token = 'ka7X7+CGCPmlt7cdfSA7HzkbUP58IVSBSBIJ/81VM0Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)