UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DyhYJFJji6lvNPbJ43wJ99ei/GmmyiJ5yMruFi5cJpg='
WHERE
key_id = 'c68ee9e182bf267731f4fe0b20d0d27d119d9e1e08e8275c0f92a05f6f6408e4'
AND (
token = 'DyhYJFJji6lvNPbJ43wJ99ei/GmmyiJ5yMruFi5cJpg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)