UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7zIFbtYqFbE1cWRrXlEaNBl26VDbQvL0YUBrI8u57Ws='
WHERE
key_id = '2b991c471005125b78f7a4e7ccb48c5300a42e2a3e3f88088b785ed39549a7d7'
AND (
token = '7zIFbtYqFbE1cWRrXlEaNBl26VDbQvL0YUBrI8u57Ws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)