UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mvpalY9MnqWoDsxg2GAG0sCvFsseN2om1X4aSOyft5Q='
WHERE
key_id = '847b5bb4d814156ae8867438f67c3c07a6fbd13d6723b4686b79f32f5d59d66c'
AND (
token = 'mvpalY9MnqWoDsxg2GAG0sCvFsseN2om1X4aSOyft5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)