UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7tJmkjPGrYwS82qOcMx9KjQQ1g5GyF02h7QsrL2F4ig='
WHERE
key_id = '812b588136041a8a43e5780dc8a8ac02134c64abe2a622a4103c8207a6c5dcf9'
AND (
token = '7tJmkjPGrYwS82qOcMx9KjQQ1g5GyF02h7QsrL2F4ig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)