UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i4GvgPoWx2CorssYbRzqaJXhTiXBraf9J0cAPd09Os4='
WHERE
key_id = '7046be6c52847d0ed882bad0ba7d4a7e8e9576b881d2dc5d88b362f0e087d499'
AND (
token = 'i4GvgPoWx2CorssYbRzqaJXhTiXBraf9J0cAPd09Os4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)