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